﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="NEWUserExportFile.aspx.cs" Inherits="mpsalaryprojectgroup.NEWUserExportFile" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Welcome to the PGS Portal</title>

    <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/excite-bike/jquery-ui.css" type="text/css" />
    <script type = "text/javascript" src = "https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
    <script type = "text/javascript" src = "https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>
   

    <style type="text/css">
        .style5
        {
            color: #FF9933;
        }
        .style8
        {
            color: #666666;
        }
        .style9
        {
            text-decoration: underline;
            color: #663300;
        }
    </style>

</head>
<body>

 <%--<div id="dialog-message" title="Download complete">
	<p>
		<span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>
		Your files have downloaded successfully into the My Downloads folder.
	</p>

</div>
<script type="text/javascript">
    $(function () {

        $('#btnsave').click(function () {
            $('#ImageButton1').click()
            $("#dialog-message").dialog('open');
        });

        $("#dialog-message").dialog({
            autoOpen: false,
            resizable: false,
            height: 260,
            modal: true,
            buttons: {
                Ok: function () {
                    $(this).dialog("close");
                }
            }
        });
    });
	</script>--%>

    <form id="form1" runat="server">
    <meta charset="utf-8" />

	<!-- Set the viewport width to device width for mobile -->
	<meta name="viewport" content="initial-scale=1, maximum-scale=1" />

	<title>Welcome to Foundation</title>
  
	<!-- Included CSS Files -->
	<link rel="stylesheet" href="CSS\foundation.css">
	<link rel="stylesheet" href="CSS\app.css">
    <link rel="stylesheet" href="CSS\ie.css">



	<!-- IE Fix for HTML5 Tags -->
	<!--[if lt IE 9]>
		<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
	<![endif]-->

    <!--CSS for hover over navigation tab-->
    
    <link rel="stylesheet" href="CSS/Tab.css">
    <script type="text/javascript" src="dropdown_menu.js"></script>
    <script type="text/javascript">
        var websiteID = 'thedesignsuperhero.com';
    </script>
    <script type="text/javascript" src="http://analytics.hosting24.com/s.php"></script>
    <noscript>
    <a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/s.php?websiteID=thedesignsuperhero.com" alt="web hosting" /></a>
    </noscript>

    <!--Navigation tab part 2 -->
<script>
    // Javascript originally by Patrick Griffiths and Dan Webb.
    // http://htmldog.com/articles/suckerfish/dropdowns/
    sfHover = function () {
        var sfEls = document.getElementById("navbar").getElementsByTagName("li");
        for (var i = 0; i < sfEls.length; i++) {
            sfEls[i].onmouseover = function () {
                this.className += " hover";
            }
            sfEls[i].onmouseout = function () {
                this.className = this.className.replace(new RegExp(" hover\\b"), "");
            }
        }
    }
    if (window.attachEvent) window.attachEvent("onload", sfHover);
</script>
    
    <%--<link rel="stylesheet" href="CSS\Tab1.css">--%>
   

    <div class="container">
		<div class="row">
			<div class="twelve columns" align="center">
				<h2><img alt="" src="Images/orangesample%20copy.jpg" /></h2>
			</div>
		</div>
    </div>

      <div class="row">
        <!--for navigation tab-->
          <%--<ul id="button">

         <li><a href="#">Home</a></li>
         <li><a href="#">About</a></li>
         <li><a href="#">Services</a></li>
         <li><a href="#">Clients</a></li>
         <li><a href="#">Products</a></li>
         <li><a href="#">F.A.Q</a></li>
         <li><a href="#">Contact Us</a></li>
         <li><a href="/NEWMainPage.aspx">Sign Out</a></li>
           </ul>--%>


       <!--Navigation part 2-->
        
		<ul id="navbar">
			<li><a href="NEWUserExportFile.aspx">Home</a>
            <!-- put link to link back to homepage -->
			</li>
                <%--<li><a href="/NEWUserExportFile.aspx">View Result</a>
				<ul>
					<li><a href="/NEWUserExportFile.aspx">Past Result</a></li>
				</ul>			
			</li>--%>
            <li><a href="NEWAnalytical.aspx">Analytical</a>
                <ul>
                    <li><a href="NEWAnalytical.aspx">Analyse</a></li>
                    <li><a href="NEWNEWReport.aspx">Report</a></li>
                </ul>
            </li>

			<li><a href="NEWContactUs.aspx">Contact Us</a>
				<!--put contact details plus google map-->		
			</li>
			<li><a href="NEWUserUpdatePage.aspx">Account</a>	
                <ul>
					<li><a href="NEWUserUpdatePage.aspx">Update Account</a></li>
                    <li><a href="NEWDelete.aspx">Delete Account</a></li>
					    <%--<li><a href="/NEWMainPage.aspx">Logout</a></li>--%>
				</ul>             	
			</li>
            <li><a href="NEWMainPage.aspx">Logout</a>		
			</li>
		</ul>
    </div>

        <div class="two columns">
        </div>
        </div>
            <div class="row">
        <div class="twelve columns">
            Dear
            <asp:Label ID="lblUsername" runat="server" Font-Bold="True"></asp:Label>
            ,</div>
    </div>
    </div>
    
    <div class="row">
        <div class="twelve columns" align="center">
            <h3 class="style5">View Latest Results</h3>
        </div>
    </div>


    <%--<div class="row">
        <div class="twelve columns" align="center">
            Results are compiled from the annual Graduate Employment Survey (GES) to 
            ascertain the employment status of graduates from the five polytechnics. These 
            results help polytechnics develop a composite picture of the employment 
            landscape, enhance curriculum, and provide better guidance on further studies 
            fro graduating students.<br />
            <br />

        </div>--%>    <%--</div>--%>
<div class="row">
        <div class="four columns" style="background-color: #FFCC99">
            <strong><span class="style9">Abbreviation of unknown data</span><br />
            <span class="style8">s </span> </strong><span class="style8">Data have been suppressed because the number of employed 
            graduate respondents was less than 10 and / or the proportion of respondents is 
            low.<strong><br />
              n.a.</strong>  Not available. <br />
               <strong>-/nil </strong>Nil or negligible.</span><br /></div>

               <div class="four columns" align="center" 
            style="background-color: #FFCC99">
        <span class="style9"><strong>Abbreviation for Name of&nbsp; School</strong></span><br />
                   <span class="style8">NYP refers to Nanyang Polytechnic<br />
            NP refers to Ngee Ann Polytechnic<br />
            SP refers to Singapore Polytechnic<br />
            TP refers to Temasek Polytechnic<br />
            RP refers to Republic Polytechnic</span><br />
                   <br />
        </div>
            

        <div class="four columns" align="center">
                    <span class="style8">If you wish to save this latest result in excel format</span><br />
                    <%--<button id="btnsave" type="button" >SAVE</button>--%>
                    <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/save_all.png" 
                        onclick="ImageButton1_Click1" ToolTip="Save Document"/>
                    <br />
                    <asp:Label ID="lblSave" runat="server" ForeColor="#666666" 
                        Text="File has been saved and stored in download folder"></asp:Label>
                    <br />
            </div>
        
        </div>

    <div class="row">
        <div class="twelve columns" align="left">
            <asp:Panel ID="PanelView0" runat="server" Width="277px">
                <asp:GridView ID="GridViewExcel0" runat="server" HorizontalAlign="Center" 
                    AutoGenerateColumns="False" DataKeyNames="Year,Course" 
                    DataSourceID="SqlDataSource2" TextWrapping="Wrap" 
                    CaptionAlign="Top" BackColor="LightGoldenrodYellow" 
                    BorderColor="Tan" BorderWidth="1px" CellPadding="2" Font-Size="X-Small" 
                    ForeColor="#C68E17" GridLines="None">
                        <AlternatingRowStyle BackColor="PaleGoldenrod" />
                        <Columns>
                        <asp:BoundField DataField="Year" HeaderText="Year" ReadOnly="True" 
                        SortExpression="Year" />
                    <asp:BoundField DataField="Course" HeaderText="Course" ReadOnly="True" 
                        SortExpression="Course" />
                            <asp:BoundField DataField="IsIndustrial" HeaderText="IsIndustrial" 
                                SortExpression="IsIndustrial" />
                    <asp:BoundField DataField="PolyConducting" HeaderText="Poly Conducting Course" 
                        SortExpression="PolyConducting" />
                    <asp:BoundField DataField="FreshGradsEmpNum" HeaderText="Fresh Graduates Employment Number" 
                        SortExpression="FreshGradsEmpNum" />
                    <asp:BoundField DataField="FreshGradsEmpRate" HeaderText="Fresh Graduates Employment Rate" 
                        SortExpression="FreshGradsEmpRate" />
                    <asp:BoundField DataField="FreshGradsMonthlyMean" 
                        HeaderText="Fresh Graduates Monthly Mean" SortExpression="FreshGradsMonthlyMean" />
                    <asp:BoundField DataField="FreshGradsMonthlyMedian" 
                        HeaderText="Fresh Graduates Monthly Median" 
                            SortExpression="FreshGradsMonthlyMedian" />
                    <asp:BoundField DataField="PostGradsEmpNum" HeaderText="Post Graduates Employment Number" 
                        SortExpression="PostGradsEmpNum" />
                    <asp:BoundField DataField="PostGradsEmpRate" HeaderText="Post Graduates Employment Rate" 
                        SortExpression="PostGradsEmpRate" />
                    <asp:BoundField DataField="PostGradsMonthlyMean" 
                        HeaderText="Post Graduates Monthly Mean" SortExpression="PostGradsMonthlyMean" />
                    <asp:BoundField DataField="PostGradsMonthlyMedian" 
                        HeaderText="Post Graduates Monthly Median" 
                                SortExpression="PostGradsMonthlyMedian" />
                    </Columns>
                        <FooterStyle BackColor="Tan" />
                        <HeaderStyle BackColor="Tan" Font-Bold="True" />
                        <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" 
                            HorizontalAlign="Center" />
                        <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                        <SortedAscendingCellStyle BackColor="#FAFAE7" />
                        <SortedAscendingHeaderStyle BackColor="#C68E17" />
                        <SortedDescendingCellStyle BackColor="#E1DB9C" />
                        <SortedDescendingHeaderStyle BackColor="#C2A47B" />
                </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:dbConn %>" 
                        SelectCommand="SELECT * FROM [Wages] WHERE ([Year] = @Year)">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="2010" Name="Year" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
            </asp:Panel>
        </div>
    </div>

    <div class="row">
            <div class="twelve columns" align="center">
            </div>
        </div>
       
        <div class="row">
            <div class="twelve columns" align="center">
            <asp:Panel ID="PanelView" runat="server" Width="945px">
                </asp:Panel>
            </div>
        </div>


    <div class="row">
        <div class="twelve columns" align="center">
            <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/school.JPG" />
            <div class="six column"></div>
        </div>
    </div>
    

    

    <!-- Included JS Files -->
	<script src="javascripts/foundation.js"></script>
	<script src="javascripts/app.js"></script>

    </form>
</body>
</html>